Open topic with navigation

Kourier Integrator Online Help

Fixing Corrupt Indexes with Net Change

According to the U2 documentation, if index corruption is found, the best practice is to delete the index with the DELETE.INDEX filename ALL command, and then to recreate the indexes. Because Kourier Net Change leverages the Index functionality to update files outside of your system's base files, the proper procedure would be the following:

1. Use the command TCL command LIST.INDEX filename to get the list of indexed fields
2. Remove the U2 file indexes with the command DELETE.INDEX filename ALL
3. Create new U2 file indexes for the indexed fields found earlier with the LIST.INDEX command. See the U2 documentation for the CREATE.INDEX command. Do not try to create the index for KCL_INDEX.
4. Create the Kourier Net Change index by executing the following commands from TCL:
       : SELECT KT_EXPORTS WITH F15 = "filename"
       > KT.SETUPNETCHG
5. Build the new indexes with the TCL command BUILD.INDEX filename ALL
6. Run a Kourier Service for all affected Exports in Full Refresh mode.

Contact Kore Technologies if you need additional assistance with this procedure.

Related Topics: 

Kourier Integrator Setup and Administration

Kourier TCL Commands Overview